set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
alter PROCEDURE [dbo].[modificarCliente]
   	 @paramDni AS int 
	,@paramNombre as nchar(100)
	,@paramApellido as nchar (40)
	,@paramDomicilio as nchar(50)
	,@paramFechaNac as datetime
	,@paramTel as int
	,@paramCel as int 
	

AS
UPDATE [Yanapay].[dbo].[Clientes]
   SET [nombre] = @paramNombre
	  ,[Apellido]= @paramApellido
	  ,[Domicilio]=@paramDomicilio
      ,[F_Nac] = @paramFechaNac
	  ,[Tel]=@paramTel
	  ,[Cel]=@paramCel
	 
      
      
 WHERE  @paramDni = [DNI/CUIT]

